HTTP connection

 

Connecting to SQL Server 2005 Analysis Services over HTTP protocol

 

Requirements:

HTTP access to SQL Server 2005 Analysis Services has successfully been configured on a windows server.

You have been given access rights to connect to the server (depends on the server configured security settings)

 

1.       URL address

In order to connect to AS over http you must know the „path“ – that is the URL address  for the connection

to be established.

This URL address maps to the AS pump component loaded into IIS (Internet Information Services) on some

windows server and serves as an ISAPI extension, pumping data from the client to an Analysis Services

server and back. Depending on the server configuration the HTTP pump can reside on a different server

than the Analysis Services server you will be using as the data source.

 

Enter the path to your virtual directory concatenated with “msmdpump.dll” in the server text box.

 

2.       Identification

CubePlayer's connect dialog supports different types of authentication:

·         Anonymous

·         Basic (provide username and password in the provided text boxes)

·         Integrated (use the check box)

 

The type of authentication and possibly the credentials that you may have to provide to identify yourself

depend on the server configured security settings (and/or your location – intranet, VPN, www).

Contact the server administrator to find out what type of authentication is required.

 

 

 

 

Example for integrated security (the LAN scenario):

 

Your administrator has configured HTTP access to SQL Server 2005 Analysis Services on a company server named „BI_SERVER“ in the virtual directory „AS2005“.

In order to minimize potential security issues the administrator has restricted the authentication to integrated security only.

 

To connect to the server from CubePlayer, you should enter the path to your virtual directory concatenated with “msmdpump.dll” in the server text box that is „http://BI_SERVER/AS2005/msmdpump.dll“ and check the Integrated security checkbox.